<?php
/**
 * Zend Framework
 *
 * LICENSE
 *
 * This source file is subject to the new BSD license that is bundled
 * with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://framework.zend.com/license/new-bsd
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@zend.com so we can send you a copy immediately.
 *
 * @category   Zend
 * @package    Zend_Amf
 * @subpackage Parse
 * @copyright  Copyright (c) 2005-2011 Zend Technologies USA Inc. (http://www.zend.com)
 * @license    http://framework.zend.com/license/new-bsd     New BSD License
 * @version    $Id: MysqlResult.php 23775 2011-03-01 17:25:24Z ralph $
 */

/**
 * This class will convert mysql result resource to array suitable for passing
 * to the external entities.
 *
 * @package    Zend_Amf
 * @subpackage Parse
 * @copyright  Copyright (c) 2005-2011 Zend Technologies USA Inc. (http://www.zend.com)
 * @license    http://framework.zend.com/license/new-bsd     New BSD License
 */
class Zend_Amf_Parse_Resource_MysqlResult {
	/**
	 * @var array List of Mysql types with PHP counterparts
	 *
	 * Key => Value is Mysql type (exact string) => PHP type
	 */
	public static $fieldTypes = array ("int" => "int", "timestamp" => "int", "year" => "int", "real" => "float" );
	/**
	 * Parse resource into array
	 *
	 * @param resource $resource
	 * @return array
	 */
	public function parse($resource) {
		$result = array ();
		$fieldcnt = mysql_num_fields ( $resource );
		$fields_transform = array ();
		for($i = 0; $i < $fieldcnt; $i ++) {
			$type = mysql_field_type ( $resource, $i );
			if (isset ( self::$fieldTypes [$type] )) {
				$fields_transform [mysql_field_name ( $resource, $i )] = self::$fieldTypes [$type];
			}
		}
		
		while ( $row = mysql_fetch_object ( $resource ) ) {
			foreach ( $fields_transform as $fieldname => $fieldtype ) {
				settype ( $row->$fieldname, $fieldtype );
			}
			$result [] = $row;
		}
		return $result;
	}
}
